Account Transaction History (GL30000)

SELECT
       ['Account Transaction History'].SOURCDOC AS 'Account Transaction History-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Account Transaction History'].SOURCDOC = ['Source Document Master'].SOURCDOC

SELECT
       ['Account Transaction History'].ACTINDX AS 'Account Transaction History-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Account Transaction History'].ACTINDX = ['Account Index Master'].ACTINDX

SELECT
       ['Account Transaction History'].LASTUSER AS 'Account Transaction History-Last User'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Account Transaction History'].LASTUSER = ['Users Master'].USERID

SELECT
       ['Account Transaction History'].USWHPSTD AS 'Account Transaction History-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Account Transaction History'].USWHPSTD = ['Users Master'].USERID

SELECT
       ['Account Transaction History'].ORCTRNUM AS 'Account Transaction History-Originating Control Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['Account Transaction History'].ORCTRNUM = ['PM Key Master File'].CNTRLNUM

SELECT
       ['Account Transaction History'].ORMSTRID AS 'Account Transaction History-Originating Master ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Account Transaction History'].ORMSTRID = ['PM Vendor Master File'].VENDORID

SELECT
       ['Account Transaction History'].CURNCYID AS 'Account Transaction History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Account Transaction History'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['Account Transaction History'].CURRNIDX AS 'Account Transaction History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Account Transaction History'].CURRNIDX = ['Currency Setup'].CURRNIDX

SELECT
       ['Account Transaction History'].RATETPID AS 'Account Transaction History-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Account Transaction History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID

SELECT
       ['Account Transaction History'].EXGTBLID AS 'Account Transaction History-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Account Transaction History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID

SELECT
       ['Account Transaction History'].NOTEINDX AS 'Account Transaction History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Account Transaction History'].NOTEINDX = ['Record Notes Master'].NOTEINDX

0	Not intercompany.
1	Intercompany

SELECT
       ['Account Transaction History'].ORCOMID AS 'Account Transaction History-Originating Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Account Transaction History'].ORCOMID = ['Company Master'].CMPANYID

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.

SELECT
       ['Account Transaction History'].APRVLUSERID AS 'Account Transaction History-Approval User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL30000 AS ['Account Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Account Transaction History'].APRVLUSERID = ['Users Master'].USERID